<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateCaCustomerDiseases extends \App\Utils\CreateMigration
{
    function columns(Blueprint $table)
    {
        $table->unsignedBigInteger('customer_id')->default(0)->comment('预约ID');
        $table->unsignedBigInteger('disease_id')->default(0)->comment('病种ID');
        $table->unique(['customer_id', 'disease_id', 'deleted_at'], 'uk_customer_disease');
    }

    function tableInfo()
    {
        return ['ca__customer_diseases', '咨询预约-客户病种'];
    }
}